Use this method to create a tab on the ribbon to open Access Studio 

 If you are already using custom ribbons, adapt the following to your requirements
 1. Create  a Table  called UsysRibbons with the following fields
   ID - autonumber
   RibbonName - text
   RibbonXML - longtext/memo
 
   populate RibbonName with 'Access Studio'  copy and paste the following XML to the RibbonXML field
 
 <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
     <ribbon startFromScratch="false">
         <tabs>
             <tab id="MyCustomTab" label="Access Studio" insertAfterMso="TabView" >
                 <group id="customGroup1" label="Options">
                     <button id="customButton1" label="Open Access Studio" imageMso="HappyFace" size="large" onAction="ribAccessStudio" />
                 </group>
             </tab>
         </tabs>
     </ribbon>
 </customUI>
 
 2. In a standard module, create the following public function
 
 Function ribAccessStudio(Control)
   OpenAccessStudio
 End Function
 
 3. Compile and compact/repair
 
 4. Now go to File/Options/Current Database and in the Ribbon and Toolbars section, select Access Studio for Ribbon Name
 
 5. Finally close and reopen the database. You should now see an Access Studio tab. Click on it and then click the happy face to open Access Studio
 
       
